package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "user_pingan_info", simpleName = "", engine = MysqlDriver.InnoDB, comment = "用户平安银行信息")
public class _DDL_UserPinganInfo {

    @_DDL_Primary()
    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer userId;

    @_DDL_Column(name = "TRUE_NAME", type = SqlType.VARCHAR, size = 40, nullable = false, comment = "姓名")
    private String trueName;

    @_DDL_Column(name = "MOBILE_NO", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "手机号")
    private String mobileNo;

    @_DDL_Column(name = "ID_TYPE", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "证件类型")
    private String idType;

    @_DDL_Column(name = "ID_NO", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "身份证")
    private String idNo;

    @_DDL_Column(name = "BANK_NAME", type = SqlType.VARCHAR, size = 50, comment = "银行名称")
    private String bankName;

    @_DDL_Column(name = "BIND_CARD_NO", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "绑定的银行卡号")
    private String bindCardNo;

    @_DDL_Column(name = "THIRD_ID", type = SqlType.VARCHAR, size = 35, comment = "第三方会员ID")
    private String thirdId;

    @_DDL_Column(name = "BUSINESS_NO", type = SqlType.VARCHAR, size = 35, comment = "业务流水号")
    private String businessNo;

    @_DDL_Column(name = "ACCOUNT_STATUS", type = SqlType.VARCHAR, size = 1, comment = "三类户状态")
    private String accountStatus;

    @_DDL_Column(name = "ACCOUNT_NO", type = SqlType.VARCHAR, size = 35, comment = "三类户卡号")
    private String accountNo;

    @_DDL_Column(name = "SIGN_ID", type = SqlType.VARCHAR, size = 35, comment = "支付签约号")
    private String signId;

    @_DDL_Column(name = "AGREEMENT_NO", type = SqlType.VARCHAR, size = 35, comment = "协议号")
    private String agreementNo;

    @_DDL_Column(name = "CREATE_TIME", type = SqlType.VARCHAR, size = 19, nullable = false, comment = "创建时间")
    private String createTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.VARCHAR, size = 19, nullable = false, comment = "更新时间")
    private String updateTime;

    @_DDL_Column(name = "IS_ID_IMG", type = SqlType.INT, nullable = false, comment = "是否需要身份证照片")
    private Integer isIdImg;

    @_DDL_Column(name = "IS_HOME", type = SqlType.INT, nullable = false, comment = "是否需要家庭地址和职业信息")
    private Integer isHome;

    @_DDL_Column(name = "TRUE_NAME_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "姓名密文")
    private String trueNameCiphertext;

    @_DDL_Column(name = "MOBILE_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "手机号密文")
    private String mobileNoCiphertext;

    @_DDL_Column(name = "ID_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "身份证密文")
    private String idNoCiphertext;

    @_DDL_Column(name = "BIND_CARD_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "绑定的银行卡号密文")
    private String bindCardNoCiphertext;

    @_DDL_Column(name = "ERR_MSG", type = SqlType.VARCHAR, size = 300, comment = "失败原因")
    private String errMsg;

    @_DDL_Column(name = "ERR_CODE", type = SqlType.VARCHAR, size = 30, comment = "失败代码")
    private String errCode;

}
